package com.example.mapper;

import com.example.entity.Student;
import com.mysql.cj.xdevapi.Column;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

public interface MainMapper {

    @Results({
            @Result(column = "s_id",property = "SID"),
            @Result(column = "s_name",property = "SName")
    })
    @Select("select * from student where s_id=#{SID}")
    Student getStudentBySID(@Param("SID") int SID);
}
